﻿CREATE PROCEDURE [dbo].[UpdateCargo]
	(@Name nvarchar(100), 
	@NameEng nvarchar(120), 
	@Description nvarchar(250), 
	@DescriptionEng nvarchar(250), 
	@ShortCode nchar(5), 
	@Code nchar(6), 
	@CodeGNG nchar(8), 
	@Mnemocode nvarchar(12), 
	@MnemocodeEng nvarchar(30), 
	@IsUsed bit, 
	@IsEmpty bit,
	@Cargo_ID int)
AS
	UPDATE Cargo 
	SET 
		Name = @Name,
		NameEng = @NameEng,
		Description = @Description,
		DescriptionEng = @DescriptionEng,
		ShortCode = @ShortCode,
		Code = @Code,
		CodeGNG = @CodeGNG, 
		Mnemocode = @Mnemocode,
		MnemocodeEng = @MnemocodeEng, 
		IsUsed = @IsUsed,
		IsEmpty = @IsEmpty 
		WHERE Cargo_ID = @Cargo_ID
RETURN 0
